Functions And Formula in Ms- Excel


 
 
Concept Explanation
 

Functions And Formula in Ms- Excel

In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.

Formula is an expression that calculates values in a cell or in a range of cells.

               For example, =A1+A2+A3+A4 is a formula that adds up the values in cells A1 through A4.

Whereas,

.... (More Text Available, Login?)
Sample Questions
(More Questions for each concept available in Login)
Question : 1

 Which of the following functions is used to find the total of a range of cells?

 

Right Option : D
View Explanation
Explanation
Question : 2

If you want to display the remainder after you divide 100 by 3, then you should use _______________

Right Option : A
View Explanation
Explanation
Question : 3

_________ is not a valid formula in MS Excel.

Right Option : B
View Explanation
Explanation
 
 
 


Students / Parents Reviews [10]